﻿CREATE TABLE [dbo].[INVOICE_IN] (
    [ID]                      INT            IDENTITY (1, 1) NOT NULL,
    [NUMBER]                  NVARCHAR (50)  NULL,
    [REG_NUMBER]              INT            NOT NULL,
    [AREAL]                   NVARCHAR (50)  NULL,
    [NSI_CONTRACT_ID]         INT            NULL,
    [DATE]                    DATE           NULL,
    [SUM]                     MONEY          NULL,
    [NSI_CURRENCY_ID]         INT            NULL,
    [NSI_TYPE_OF_ACTIVITY_ID] INT            NULL,
    [N_FOLDER]                SMALLINT       NULL,
    [PLAN_PAY_DATE]           DATE           NULL,
    [NSI_PAY_DIRECT_ID]       INT            NULL,
    [NSI_FINANCE_RESOURCE_ID] INT            NULL,
    [NSI_EXPENSE_ITEM_ID]     INT            NULL,
    [CITY]                    NVARCHAR (50)  NULL,
    [NSI_ORGANIZATION_ID]     INT            NULL,
    [CONTRACT_NUMBER]         NVARCHAR (50)  NULL,
    [CONTRACT_DATE]           DATE           NULL,
    [STATE]                   NVARCHAR (50)  NULL,
    [DESCRIPTION]             NVARCHAR (MAX) NULL,
    [LAST_UPDATE]             DATETIME2 (7)  NULL,
    [LAST_UPDATE_USER]        NVARCHAR (50)  NULL,
    [PID]                     INT            NULL
);







